You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'd/\'Huez, base ) name,
TYPE FROM (
SELECT gl.placeid,
TYPE , MAX( IF( languageco' at line 1Fehler mit Abfrage: <br>SELECT placeid, type,COALESCE( es/Webcam-Alpe d/\'Huez, base ) name,
TYPE FROM (
SELECT gl.placeid,
TYPE , MAX( IF( languagecode = 'es/Webcam-Alpe d/\'Huez', name, NULL ) ) AS es/Webcam-Alpe d/\'Huez, MAX( IF( languagecode = baselang, name, NULL ) ) AS base
FROM places_languages gl
INNER JOIN places cs ON gl.placeid = cs.idplace
WHERE placeid = '0'
GROUP BY placeid
)subq